import mysql.connector
import time

conn = mysql.connector.connect(host='192.168.2.159', port='3300', database='znzj', user='cincc',
							   password='cinCC1234',
							   use_unicode=True)
c = conn.cursor()

start_time = time.time()
c.execute('select * from txt where txt REGEXP "^.你好.再见.$"')
end_time = time.time()
print("time long --->", end_time - start_time)
for row in c:
	print(row)
c.close()
conn.close()
